Dashboard 02 - WakeCountyRealEstate Dashboard - Creating Scatter Chart, Map, & Line and Stacked Column charts Visualizations - Part 02 14

In this step, we will continue working on the first dashboard.  We will create Line and Clustered Column chart




Step 5:  Create Line and Clustered Column Chart for AVG Year Over Year (YOY) Apartment & House Prices/Sq. Ft. by Township, Year, Quarter Month


In Power BI Desktop, click on the page, WakeCountyRealEstate

Click inside the pane

Visualizations

Click the Line and Clustered Column Chart icon

Fields

Select the following:

Under Visualizations, drag & drop it in the Shared Axis section:
DateDimension[Date] ->  Month

DateDimension[Date] ->  Year
DateDimension[Date] ->  Quarter

Township ->  .Township_Name


Under Visualizations, drag & drop it in the Column Values section:
A_KeyMeasures -> .AVG_AptUnitPrice_PerSqFt%
A_KeyMeasures -> .AVG_ResidentialPrice_PerSqFt%


Under Visualizations, drag & drop it in the Line Values section:
A_KeyMeasures ->  .YOY_AVG_AptUnitPrice_PerSqFt%
A_KeyMeasures ->  .YOY_AVG_ResidentialPrice_PerSqFt%


Under Visualizations, drag & drop it in the Tooltips section:
A_KeyMeasures -> .AVG_ResidentialPrice_PerSqFt%
A_KeyMeasures ->  .YOY_AVG_AptUnitPrice_PerSqFt%
A_KeyMeasures ->  .YOY_AVG_ResidentialPrice_PerSqFt%
A_KeyMeasures ->  .AVG_Residential_Prices
Township ->  .Township_Name
Township ->  .Township_Misc_Name







Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:



.Township_Name = Township Name


.AVG_AptUnitPrice_PerSqFt% = AVG Apt Price/Sq. Ft.
.AVG_ResidentialPrice_PerSqFt% = AVG Hse Price/Sq. Ft.


.YOY_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.
.YOY_AVG_ResidentialPrice_PerSqFt%  = YOY AVG House Price/Sq. Ft.


.Total_AptUnits = Total Apartment Units
.YOY_Diff_AVG_AptUnitPrice_PerSqFt% = YOY AVG Apt Price/Sq. Ft.
.YOY_Diff_AVG_ResidentialPrice_PerSqFt%  = YOY AVG House Price/Sq. Ft.
.AVG_Residential_Prices = AVG House Price
.Township_Name = Township Name
.Township_Misc_Name = Township Misc. Name(s)








Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 272 , Y Position = 640 , Width = 1229 , Height = 412

Under Format -> Legend ->  Set it to ON , Position = Top Center , Title = OFF , Color = #000000 , Legend Name = AVG YOY Apt. House Prices/Sq.Ft , Font Family = Segoe UI , Text Size = 13 pt , Style = Markers Only

Under Format -> X Axis -> Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF

Under Format -> Y Axis -> Position = Left , Scale Type = Linear ->  Start = 25 ,  Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Gridlines = ON , Line Color = #000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = #5B8F22 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF

Under Format ->  Data Colors -> 

YOY AVG Apt Price/Sq. Ft. = #1D0D49
YOY AVG Hse Price/Sq. Ft. = #925231

AVG Apt Price/Sq. Ft. = #868291
AVG Hse Price/Sq. Ft. = #DC8250


Under Format ->  Data Labels ->  Set it to ON , Color = #000000 , Display Units = Auto , Value Decimal Places = 0 , Text Size = 14 pt , Font Family = Segoe UI , Show Background = Off , 

Customize Series  = ON ,

(Select AVG Apt Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF) ,

(Select AVG Hse Price/Sq. Ft.  -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)

(Select YOY AVG Apt Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)

(Select YOY AVG Hse Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)

Under Format ->  Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5

Under Format -> Title ->  Set it to ON , Title Text = AVG Year Over Year (YOY) Apartment & House Prices/Sq. Ft. by Township, Year, Quarter Month , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to ON , Color = #666666 , Radius = 5 px




Final Look:





Filters

None.





When finished, save project.


For assistance in creating a Line and Clustered Column Chart in Power BI:


Tips on how to create a Line and Clustered Column Chart in Power BI